Microsoft Access Introduction to Application Development

Outcomes

Participants will learn how to transform a Microsoft Access Database into a fully functioning application by creating Custom menu's, interactive forms and adding security to an Access Application. Participants will also expand on the knowledge from Access Advanced by using advanced Macros and gaining an introduction to Visual Basic for Applications.

Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.
Microsoft Access Level 1, Level 2 and Advanced, or equivalent knowledge

What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session

---

Application design concepts Planning an application Examining a completed application Developing a distributed application design Adding command buttons to guide user navigation Using one form to add or edit records Automating a dialog-box form with a macro group Creating a macro group Customizing an unbound form as a dialog box Documenting a macro group Creating a Switchboard form Using the Switchboard Manager Setting database startup properties Working with custom toolbars and menus Using a macro group to show and hide a toolbar Using Visual Basic code to show and hide a customized form-view toolbar Creating a custom menu bar for a form Startup properties for toolbars and menus

Creating a Splash Screen form Creating a form as a splash screen Automating the Splash Screen form Modifying startup properties to display a Splash Screen form Documenting the application Using Visual Basic procedures Creating a global function Adding General procedures in a form module Creating event procedures Adding security to an application Security overview Steps to securing a database by using user-level security Documenting database security Securing a database with a database password Distributing the secured application Appendices APP.MDB diagram Planning an applications Importing spreadsheets, databases, and delimited text files